package com.power.service;

import com.power.ov.ResultData;
import com.power.ov.ResultDataTable;
import com.power.pojo.Tower;

import java.sql.SQLException;

/**
 * Created with IntelliJ IDEA.
 * User: 李辽
 * Date: 2020/10/03 17:03
 * Description:
 * Version: V1.0
 */
public interface TowerService {
    /**
     * 查询所有的杆塔信息
     * @param page 页码数
     * @param limit 每页展示的条数
     * @return
     * @throws SQLException
     */
    ResultDataTable queryListPower(int page,int limit) throws SQLException;

    /**
     * 通过杆塔编号删除该条杆塔信息
     * @param towper_id
     * @return
     */
    int DeleteTowerByName(int towper_id) throws SQLException;

    /**
     * 更改杆塔信息
     * @param tower1
     * @return
     */
    int ChangeTower(Tower tower1) throws SQLException;



    /**
     * 添加杆塔信息
     * @param tower1
     * @return
     */
    int Addtopwer(Tower tower1) throws SQLException;



    /**
     * 通过所属路线、杆塔状态筛选数据
     * @param page
     * @param limit
     * @param line_number
     * @param tower_state
     * @return
     */
    ResultDataTable SearchTower(int page, int limit, String line_number, int tower_state) throws SQLException;

    /**
     * 更改杆塔启用状态
     * @param towper_id
     * @param state_name
     * @return
     */
    int ModifiesTowerStatus(int towper_id, String state_name) throws SQLException;

    /**
     * 通过线路id查询其下所有的杆塔信息
     * @param line_id
     * @return
     */
    ResultData DefectSelect(String line_id) throws SQLException;
}
